﻿
CREATE PROCEDURE [dbo].[fares_SchimbaRegimuriFiscale]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	--peste 100 din 08.2010
	SET IDENTITY_INSERT regim_fiscal on
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(100,'Cu TVA','IO',1,1)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(101,'Cu taxare inversa','IO',1,1)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(102,'Achizitii intracomunitare de bunuri cu taxare inversa','IO',1,0)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(103,'Servicii intracomunitare cu taxare inversa','IO',1,1)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(104,'Livrari intracomunitare scutite conform art. 143 alin (2) lit. a) si d)','O',1,0)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(105,'Livrari intracomunitare scutite conform art. 143 alin (2) lit. b) si c)','O',1,0)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(106,'Scutit cu drept de deducere','O',1,0)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(107,'Scutit fara drept de deducere','O',1,0)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(108,'Achizitii de bunuri si servicii neimpozabile','I',1,1)
	INSERT INTO [regimfiscal] ([IDRegimFiscal],[Denumire],[TipOperatie],[Vizibil],[CuTVA])VALUES(109,'Achizitii bunuri si servicii scutite','I',1,1)
	SET IDENTITY_INSERT regim_fiscal off

END